SUPPORT / SAMPLES & SAS NOTES
Problem Note 38643: "Write Access Violation" error issued with PROC FREQ two-way table with the MISSING= option
 |  |  |  |
The following error might be issued when generating a PROC FREQ two-way table where one of the variables contains all missing values and OPTIONS MISSING=' ' has been specified:
ERROR: Write Access Violation In Task [ FREQ ]
In addition to the error, only some header information will display in the results.
To circumvent the problem, create a user-defined format to display blanks for missing values instead of specifying the MISSING=' ' option on an OPTIONS statement. The code below illustrates the circumvention.
data test; /* creating sample data set */
a=1; b=.; output;
a=2; b=.; output;
a=2; b=.; output;
a=3; b=.; output;
a=3; b=.; output;
a=3; b=.; output;
run;
proc format;
value myfmt
.=' '
other=[8.];
run;
options missing=' ';
proc freq data=test;
table a * b / missing;
format b myfmt.;
/* Removal of or commenting the FORMAT statement will result in the error */
run;
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.2 TS1M0 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.2 TS1M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Linux | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Linux for x64 | 9.2 TS1M0 | 9.3 TS1M0 | ||
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 9.2 TS1M0 | 9.3 TS1M0 | ||